CREATE TABLE [dbo].[TMCNTA_SARE]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_BANC] [dbo].[TD_VC_003] NOT NULL,
[NU_CNTA_BANC] [dbo].[TD_VC_020] NOT NULL,
[FE_SALD_REAL] [dbo].[TD_DT_001] NOT NULL,
[IM_SALD_REAL] [dbo].[TD_NU_016_004] NOT NULL CONSTRAINT [DF__TMCNTA_SA__IM_SA__45FE52CB] DEFAULT ((0)),
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TMCNTA_SA__CO_US__46F27704] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMCNTA_SA__FE_US__47E69B3D] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TMCNTA_SA__CO_US__48DABF76] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMCNTA_SA__FE_US__49CEE3AF] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMCNTA_SARE] ADD CONSTRAINT [PK__TMCNTA_S__02D4A61A38CF4036] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_BANC], [NU_CNTA_BANC], [FE_SALD_REAL]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMCNTA_SARE] ADD CONSTRAINT [FK__TMCNTA_SARE__76EC6E40] FOREIGN KEY ([CO_EMPR], [CO_BANC], [NU_CNTA_BANC]) REFERENCES [dbo].[TMCNTA_BANC] ([CO_EMPR], [CO_BANC], [NU_CNTA_BANC])
GO
